Data generation and analysis using spreadsheets

Scalable Spreadsheets for Interactive Data Analysis

Interactive responses and natural, intuitive controls are important for data analysis. We are building ABC, a scal-able spreadsheet for data analysis that combines exploration , grouping, and aggregation. We focus on interactive responses in place of long delays, and intuitive, direct-manipulation operations in place of complex queries. ABC allows analysts to interactively explore the data at v...

Frequent Data Generation Using Relative Data Analysis

Traditional association rule mining method mines association rules only for the items bought by the customer. However an actual transaction consists of the items bought by the customer along with the quantity of items bought. This paper reconsiders the traditional database by taking into account both items as well as its quantity. This new transaction database is named as bag database and each ...

Failure Mode and Effects Analysis Using Data Envelopment Analysis

Utilization of Electronic Spreadsheets for Laboratory Data Analysis

The util i zati on of busi ness spreadsheets for 1aboratory data mani pul ati on is di scussed. The spreadsheet, LOTUS 1-2-3, is presently being utilized to store and analyze data obtained from a deep cavity resonator type apparatus. Methodology for the analysis, frqm non dimensionalization of parameters, to relavent plotting of data pa irs, is presented. All di scussi ons are based upon curren...

Analysis and improvement of business process models using spreadsheets

Software in general is thoroughly analyzed before it is released to its users. Business processes often are not – at least not as thoroughly as it could be – before they are released to their users, e.g., employees or software agents. This paper ascribes this practice to the lack of suitable instruments for business process analysts, who design the processes, their processes. We use the spreads...